package com.desksoft.ecommerce.entity.mall.dto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OneclkExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OneclkExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("Name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("Name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("Name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("Name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("Name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("Name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("Name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("Name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("Name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("Name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("Name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("Name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("Name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("Name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andRsexIsNull() {
            addCriterion("RSex is null");
            return (Criteria) this;
        }

        public Criteria andRsexIsNotNull() {
            addCriterion("RSex is not null");
            return (Criteria) this;
        }

        public Criteria andRsexEqualTo(Integer value) {
            addCriterion("RSex =", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexNotEqualTo(Integer value) {
            addCriterion("RSex <>", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexGreaterThan(Integer value) {
            addCriterion("RSex >", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexGreaterThanOrEqualTo(Integer value) {
            addCriterion("RSex >=", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexLessThan(Integer value) {
            addCriterion("RSex <", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexLessThanOrEqualTo(Integer value) {
            addCriterion("RSex <=", value, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexIn(List<Integer> values) {
            addCriterion("RSex in", values, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexNotIn(List<Integer> values) {
            addCriterion("RSex not in", values, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexBetween(Integer value1, Integer value2) {
            addCriterion("RSex between", value1, value2, "rsex");
            return (Criteria) this;
        }

        public Criteria andRsexNotBetween(Integer value1, Integer value2) {
            addCriterion("RSex not between", value1, value2, "rsex");
            return (Criteria) this;
        }

        public Criteria andCountryidIsNull() {
            addCriterion("CountryID is null");
            return (Criteria) this;
        }

        public Criteria andCountryidIsNotNull() {
            addCriterion("CountryID is not null");
            return (Criteria) this;
        }

        public Criteria andCountryidEqualTo(Integer value) {
            addCriterion("CountryID =", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidNotEqualTo(Integer value) {
            addCriterion("CountryID <>", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidGreaterThan(Integer value) {
            addCriterion("CountryID >", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CountryID >=", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidLessThan(Integer value) {
            addCriterion("CountryID <", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidLessThanOrEqualTo(Integer value) {
            addCriterion("CountryID <=", value, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidIn(List<Integer> values) {
            addCriterion("CountryID in", values, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidNotIn(List<Integer> values) {
            addCriterion("CountryID not in", values, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidBetween(Integer value1, Integer value2) {
            addCriterion("CountryID between", value1, value2, "countryid");
            return (Criteria) this;
        }

        public Criteria andCountryidNotBetween(Integer value1, Integer value2) {
            addCriterion("CountryID not between", value1, value2, "countryid");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNull() {
            addCriterion("ProvinceID is null");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNotNull() {
            addCriterion("ProvinceID is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceidEqualTo(String value) {
            addCriterion("ProvinceID =", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotEqualTo(String value) {
            addCriterion("ProvinceID <>", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThan(String value) {
            addCriterion("ProvinceID >", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThanOrEqualTo(String value) {
            addCriterion("ProvinceID >=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThan(String value) {
            addCriterion("ProvinceID <", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThanOrEqualTo(String value) {
            addCriterion("ProvinceID <=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLike(String value) {
            addCriterion("ProvinceID like", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotLike(String value) {
            addCriterion("ProvinceID not like", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidIn(List<String> values) {
            addCriterion("ProvinceID in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotIn(List<String> values) {
            addCriterion("ProvinceID not in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidBetween(String value1, String value2) {
            addCriterion("ProvinceID between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotBetween(String value1, String value2) {
            addCriterion("ProvinceID not between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andCityidIsNull() {
            addCriterion("CityID is null");
            return (Criteria) this;
        }

        public Criteria andCityidIsNotNull() {
            addCriterion("CityID is not null");
            return (Criteria) this;
        }

        public Criteria andCityidEqualTo(String value) {
            addCriterion("CityID =", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotEqualTo(String value) {
            addCriterion("CityID <>", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThan(String value) {
            addCriterion("CityID >", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThanOrEqualTo(String value) {
            addCriterion("CityID >=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThan(String value) {
            addCriterion("CityID <", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThanOrEqualTo(String value) {
            addCriterion("CityID <=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLike(String value) {
            addCriterion("CityID like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotLike(String value) {
            addCriterion("CityID not like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidIn(List<String> values) {
            addCriterion("CityID in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotIn(List<String> values) {
            addCriterion("CityID not in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidBetween(String value1, String value2) {
            addCriterion("CityID between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotBetween(String value1, String value2) {
            addCriterion("CityID not between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andRaddressIsNull() {
            addCriterion("RAddress is null");
            return (Criteria) this;
        }

        public Criteria andRaddressIsNotNull() {
            addCriterion("RAddress is not null");
            return (Criteria) this;
        }

        public Criteria andRaddressEqualTo(String value) {
            addCriterion("RAddress =", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressNotEqualTo(String value) {
            addCriterion("RAddress <>", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressGreaterThan(String value) {
            addCriterion("RAddress >", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressGreaterThanOrEqualTo(String value) {
            addCriterion("RAddress >=", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressLessThan(String value) {
            addCriterion("RAddress <", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressLessThanOrEqualTo(String value) {
            addCriterion("RAddress <=", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressLike(String value) {
            addCriterion("RAddress like", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressNotLike(String value) {
            addCriterion("RAddress not like", value, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressIn(List<String> values) {
            addCriterion("RAddress in", values, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressNotIn(List<String> values) {
            addCriterion("RAddress not in", values, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressBetween(String value1, String value2) {
            addCriterion("RAddress between", value1, value2, "raddress");
            return (Criteria) this;
        }

        public Criteria andRaddressNotBetween(String value1, String value2) {
            addCriterion("RAddress not between", value1, value2, "raddress");
            return (Criteria) this;
        }

        public Criteria andRzipcodeIsNull() {
            addCriterion("RZipCode is null");
            return (Criteria) this;
        }

        public Criteria andRzipcodeIsNotNull() {
            addCriterion("RZipCode is not null");
            return (Criteria) this;
        }

        public Criteria andRzipcodeEqualTo(String value) {
            addCriterion("RZipCode =", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeNotEqualTo(String value) {
            addCriterion("RZipCode <>", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeGreaterThan(String value) {
            addCriterion("RZipCode >", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeGreaterThanOrEqualTo(String value) {
            addCriterion("RZipCode >=", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeLessThan(String value) {
            addCriterion("RZipCode <", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeLessThanOrEqualTo(String value) {
            addCriterion("RZipCode <=", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeLike(String value) {
            addCriterion("RZipCode like", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeNotLike(String value) {
            addCriterion("RZipCode not like", value, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeIn(List<String> values) {
            addCriterion("RZipCode in", values, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeNotIn(List<String> values) {
            addCriterion("RZipCode not in", values, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeBetween(String value1, String value2) {
            addCriterion("RZipCode between", value1, value2, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRzipcodeNotBetween(String value1, String value2) {
            addCriterion("RZipCode not between", value1, value2, "rzipcode");
            return (Criteria) this;
        }

        public Criteria andRemailIsNull() {
            addCriterion("REmail is null");
            return (Criteria) this;
        }

        public Criteria andRemailIsNotNull() {
            addCriterion("REmail is not null");
            return (Criteria) this;
        }

        public Criteria andRemailEqualTo(String value) {
            addCriterion("REmail =", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailNotEqualTo(String value) {
            addCriterion("REmail <>", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailGreaterThan(String value) {
            addCriterion("REmail >", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailGreaterThanOrEqualTo(String value) {
            addCriterion("REmail >=", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailLessThan(String value) {
            addCriterion("REmail <", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailLessThanOrEqualTo(String value) {
            addCriterion("REmail <=", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailLike(String value) {
            addCriterion("REmail like", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailNotLike(String value) {
            addCriterion("REmail not like", value, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailIn(List<String> values) {
            addCriterion("REmail in", values, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailNotIn(List<String> values) {
            addCriterion("REmail not in", values, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailBetween(String value1, String value2) {
            addCriterion("REmail between", value1, value2, "remail");
            return (Criteria) this;
        }

        public Criteria andRemailNotBetween(String value1, String value2) {
            addCriterion("REmail not between", value1, value2, "remail");
            return (Criteria) this;
        }

        public Criteria andRphoneIsNull() {
            addCriterion("RPhone is null");
            return (Criteria) this;
        }

        public Criteria andRphoneIsNotNull() {
            addCriterion("RPhone is not null");
            return (Criteria) this;
        }

        public Criteria andRphoneEqualTo(String value) {
            addCriterion("RPhone =", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneNotEqualTo(String value) {
            addCriterion("RPhone <>", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneGreaterThan(String value) {
            addCriterion("RPhone >", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneGreaterThanOrEqualTo(String value) {
            addCriterion("RPhone >=", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneLessThan(String value) {
            addCriterion("RPhone <", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneLessThanOrEqualTo(String value) {
            addCriterion("RPhone <=", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneLike(String value) {
            addCriterion("RPhone like", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneNotLike(String value) {
            addCriterion("RPhone not like", value, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneIn(List<String> values) {
            addCriterion("RPhone in", values, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneNotIn(List<String> values) {
            addCriterion("RPhone not in", values, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneBetween(String value1, String value2) {
            addCriterion("RPhone between", value1, value2, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphoneNotBetween(String value1, String value2) {
            addCriterion("RPhone not between", value1, value2, "rphone");
            return (Criteria) this;
        }

        public Criteria andRphone1IsNull() {
            addCriterion("RPhone1 is null");
            return (Criteria) this;
        }

        public Criteria andRphone1IsNotNull() {
            addCriterion("RPhone1 is not null");
            return (Criteria) this;
        }

        public Criteria andRphone1EqualTo(String value) {
            addCriterion("RPhone1 =", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1NotEqualTo(String value) {
            addCriterion("RPhone1 <>", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1GreaterThan(String value) {
            addCriterion("RPhone1 >", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1GreaterThanOrEqualTo(String value) {
            addCriterion("RPhone1 >=", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1LessThan(String value) {
            addCriterion("RPhone1 <", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1LessThanOrEqualTo(String value) {
            addCriterion("RPhone1 <=", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1Like(String value) {
            addCriterion("RPhone1 like", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1NotLike(String value) {
            addCriterion("RPhone1 not like", value, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1In(List<String> values) {
            addCriterion("RPhone1 in", values, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1NotIn(List<String> values) {
            addCriterion("RPhone1 not in", values, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1Between(String value1, String value2) {
            addCriterion("RPhone1 between", value1, value2, "rphone1");
            return (Criteria) this;
        }

        public Criteria andRphone1NotBetween(String value1, String value2) {
            addCriterion("RPhone1 not between", value1, value2, "rphone1");
            return (Criteria) this;
        }

        public Criteria andPayidIsNull() {
            addCriterion("PayID is null");
            return (Criteria) this;
        }

        public Criteria andPayidIsNotNull() {
            addCriterion("PayID is not null");
            return (Criteria) this;
        }

        public Criteria andPayidEqualTo(Integer value) {
            addCriterion("PayID =", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidNotEqualTo(Integer value) {
            addCriterion("PayID <>", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidGreaterThan(Integer value) {
            addCriterion("PayID >", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidGreaterThanOrEqualTo(Integer value) {
            addCriterion("PayID >=", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidLessThan(Integer value) {
            addCriterion("PayID <", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidLessThanOrEqualTo(Integer value) {
            addCriterion("PayID <=", value, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidIn(List<Integer> values) {
            addCriterion("PayID in", values, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidNotIn(List<Integer> values) {
            addCriterion("PayID not in", values, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidBetween(Integer value1, Integer value2) {
            addCriterion("PayID between", value1, value2, "payid");
            return (Criteria) this;
        }

        public Criteria andPayidNotBetween(Integer value1, Integer value2) {
            addCriterion("PayID not between", value1, value2, "payid");
            return (Criteria) this;
        }

        public Criteria andShipidIsNull() {
            addCriterion("ShipID is null");
            return (Criteria) this;
        }

        public Criteria andShipidIsNotNull() {
            addCriterion("ShipID is not null");
            return (Criteria) this;
        }

        public Criteria andShipidEqualTo(Integer value) {
            addCriterion("ShipID =", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidNotEqualTo(Integer value) {
            addCriterion("ShipID <>", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidGreaterThan(Integer value) {
            addCriterion("ShipID >", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidGreaterThanOrEqualTo(Integer value) {
            addCriterion("ShipID >=", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidLessThan(Integer value) {
            addCriterion("ShipID <", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidLessThanOrEqualTo(Integer value) {
            addCriterion("ShipID <=", value, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidIn(List<Integer> values) {
            addCriterion("ShipID in", values, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidNotIn(List<Integer> values) {
            addCriterion("ShipID not in", values, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidBetween(Integer value1, Integer value2) {
            addCriterion("ShipID between", value1, value2, "shipid");
            return (Criteria) this;
        }

        public Criteria andShipidNotBetween(Integer value1, Integer value2) {
            addCriterion("ShipID not between", value1, value2, "shipid");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("Memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("Memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("Memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("Memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("Memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("Memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("Memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("Memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("Memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("Memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("Memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("Memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("Memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("Memo not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNull() {
            addCriterion("CreateDate is null");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNotNull() {
            addCriterion("CreateDate is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedateEqualTo(Date value) {
            addCriterion("CreateDate =", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotEqualTo(Date value) {
            addCriterion("CreateDate <>", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThan(Date value) {
            addCriterion("CreateDate >", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateDate >=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThan(Date value) {
            addCriterion("CreateDate <", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThanOrEqualTo(Date value) {
            addCriterion("CreateDate <=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateIn(List<Date> values) {
            addCriterion("CreateDate in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotIn(List<Date> values) {
            addCriterion("CreateDate not in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateBetween(Date value1, Date value2) {
            addCriterion("CreateDate between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotBetween(Date value1, Date value2) {
            addCriterion("CreateDate not between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNull() {
            addCriterion("UpdateDate is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNotNull() {
            addCriterion("UpdateDate is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateEqualTo(Date value) {
            addCriterion("UpdateDate =", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotEqualTo(Date value) {
            addCriterion("UpdateDate <>", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThan(Date value) {
            addCriterion("UpdateDate >", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("UpdateDate >=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThan(Date value) {
            addCriterion("UpdateDate <", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThanOrEqualTo(Date value) {
            addCriterion("UpdateDate <=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIn(List<Date> values) {
            addCriterion("UpdateDate in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotIn(List<Date> values) {
            addCriterion("UpdateDate not in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateBetween(Date value1, Date value2) {
            addCriterion("UpdateDate between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotBetween(Date value1, Date value2) {
            addCriterion("UpdateDate not between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andZoneidIsNull() {
            addCriterion("ZoneID is null");
            return (Criteria) this;
        }

        public Criteria andZoneidIsNotNull() {
            addCriterion("ZoneID is not null");
            return (Criteria) this;
        }

        public Criteria andZoneidEqualTo(String value) {
            addCriterion("ZoneID =", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidNotEqualTo(String value) {
            addCriterion("ZoneID <>", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidGreaterThan(String value) {
            addCriterion("ZoneID >", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidGreaterThanOrEqualTo(String value) {
            addCriterion("ZoneID >=", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidLessThan(String value) {
            addCriterion("ZoneID <", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidLessThanOrEqualTo(String value) {
            addCriterion("ZoneID <=", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidLike(String value) {
            addCriterion("ZoneID like", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidNotLike(String value) {
            addCriterion("ZoneID not like", value, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidIn(List<String> values) {
            addCriterion("ZoneID in", values, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidNotIn(List<String> values) {
            addCriterion("ZoneID not in", values, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidBetween(String value1, String value2) {
            addCriterion("ZoneID between", value1, value2, "zoneid");
            return (Criteria) this;
        }

        public Criteria andZoneidNotBetween(String value1, String value2) {
            addCriterion("ZoneID not between", value1, value2, "zoneid");
            return (Criteria) this;
        }

        public Criteria andCardnameIsNull() {
            addCriterion("CardName is null");
            return (Criteria) this;
        }

        public Criteria andCardnameIsNotNull() {
            addCriterion("CardName is not null");
            return (Criteria) this;
        }

        public Criteria andCardnameEqualTo(String value) {
            addCriterion("CardName =", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameNotEqualTo(String value) {
            addCriterion("CardName <>", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameGreaterThan(String value) {
            addCriterion("CardName >", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameGreaterThanOrEqualTo(String value) {
            addCriterion("CardName >=", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameLessThan(String value) {
            addCriterion("CardName <", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameLessThanOrEqualTo(String value) {
            addCriterion("CardName <=", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameLike(String value) {
            addCriterion("CardName like", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameNotLike(String value) {
            addCriterion("CardName not like", value, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameIn(List<String> values) {
            addCriterion("CardName in", values, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameNotIn(List<String> values) {
            addCriterion("CardName not in", values, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameBetween(String value1, String value2) {
            addCriterion("CardName between", value1, value2, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardnameNotBetween(String value1, String value2) {
            addCriterion("CardName not between", value1, value2, "cardname");
            return (Criteria) this;
        }

        public Criteria andCardcodeIsNull() {
            addCriterion("CardCode is null");
            return (Criteria) this;
        }

        public Criteria andCardcodeIsNotNull() {
            addCriterion("CardCode is not null");
            return (Criteria) this;
        }

        public Criteria andCardcodeEqualTo(String value) {
            addCriterion("CardCode =", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeNotEqualTo(String value) {
            addCriterion("CardCode <>", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeGreaterThan(String value) {
            addCriterion("CardCode >", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeGreaterThanOrEqualTo(String value) {
            addCriterion("CardCode >=", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeLessThan(String value) {
            addCriterion("CardCode <", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeLessThanOrEqualTo(String value) {
            addCriterion("CardCode <=", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeLike(String value) {
            addCriterion("CardCode like", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeNotLike(String value) {
            addCriterion("CardCode not like", value, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeIn(List<String> values) {
            addCriterion("CardCode in", values, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeNotIn(List<String> values) {
            addCriterion("CardCode not in", values, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeBetween(String value1, String value2) {
            addCriterion("CardCode between", value1, value2, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardcodeNotBetween(String value1, String value2) {
            addCriterion("CardCode not between", value1, value2, "cardcode");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateIsNull() {
            addCriterion("CardValidDate is null");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateIsNotNull() {
            addCriterion("CardValidDate is not null");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateEqualTo(Date value) {
            addCriterion("CardValidDate =", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateNotEqualTo(Date value) {
            addCriterion("CardValidDate <>", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateGreaterThan(Date value) {
            addCriterion("CardValidDate >", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateGreaterThanOrEqualTo(Date value) {
            addCriterion("CardValidDate >=", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateLessThan(Date value) {
            addCriterion("CardValidDate <", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateLessThanOrEqualTo(Date value) {
            addCriterion("CardValidDate <=", value, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateIn(List<Date> values) {
            addCriterion("CardValidDate in", values, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateNotIn(List<Date> values) {
            addCriterion("CardValidDate not in", values, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateBetween(Date value1, Date value2) {
            addCriterion("CardValidDate between", value1, value2, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andCardvaliddateNotBetween(Date value1, Date value2) {
            addCriterion("CardValidDate not between", value1, value2, "cardvaliddate");
            return (Criteria) this;
        }

        public Criteria andOosselectIsNull() {
            addCriterion("OOSselect is null");
            return (Criteria) this;
        }

        public Criteria andOosselectIsNotNull() {
            addCriterion("OOSselect is not null");
            return (Criteria) this;
        }

        public Criteria andOosselectEqualTo(Integer value) {
            addCriterion("OOSselect =", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectNotEqualTo(Integer value) {
            addCriterion("OOSselect <>", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectGreaterThan(Integer value) {
            addCriterion("OOSselect >", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectGreaterThanOrEqualTo(Integer value) {
            addCriterion("OOSselect >=", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectLessThan(Integer value) {
            addCriterion("OOSselect <", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectLessThanOrEqualTo(Integer value) {
            addCriterion("OOSselect <=", value, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectIn(List<Integer> values) {
            addCriterion("OOSselect in", values, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectNotIn(List<Integer> values) {
            addCriterion("OOSselect not in", values, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectBetween(Integer value1, Integer value2) {
            addCriterion("OOSselect between", value1, value2, "oosselect");
            return (Criteria) this;
        }

        public Criteria andOosselectNotBetween(Integer value1, Integer value2) {
            addCriterion("OOSselect not between", value1, value2, "oosselect");
            return (Criteria) this;
        }

        public Criteria andExcessmnysIsNull() {
            addCriterion("Excessmnys is null");
            return (Criteria) this;
        }

        public Criteria andExcessmnysIsNotNull() {
            addCriterion("Excessmnys is not null");
            return (Criteria) this;
        }

        public Criteria andExcessmnysEqualTo(Integer value) {
            addCriterion("Excessmnys =", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysNotEqualTo(Integer value) {
            addCriterion("Excessmnys <>", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysGreaterThan(Integer value) {
            addCriterion("Excessmnys >", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysGreaterThanOrEqualTo(Integer value) {
            addCriterion("Excessmnys >=", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysLessThan(Integer value) {
            addCriterion("Excessmnys <", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysLessThanOrEqualTo(Integer value) {
            addCriterion("Excessmnys <=", value, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysIn(List<Integer> values) {
            addCriterion("Excessmnys in", values, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysNotIn(List<Integer> values) {
            addCriterion("Excessmnys not in", values, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysBetween(Integer value1, Integer value2) {
            addCriterion("Excessmnys between", value1, value2, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andExcessmnysNotBetween(Integer value1, Integer value2) {
            addCriterion("Excessmnys not between", value1, value2, "excessmnys");
            return (Criteria) this;
        }

        public Criteria andRthirdIsNull() {
            addCriterion("RThird is null");
            return (Criteria) this;
        }

        public Criteria andRthirdIsNotNull() {
            addCriterion("RThird is not null");
            return (Criteria) this;
        }

        public Criteria andRthirdEqualTo(Integer value) {
            addCriterion("RThird =", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdNotEqualTo(Integer value) {
            addCriterion("RThird <>", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdGreaterThan(Integer value) {
            addCriterion("RThird >", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdGreaterThanOrEqualTo(Integer value) {
            addCriterion("RThird >=", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdLessThan(Integer value) {
            addCriterion("RThird <", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdLessThanOrEqualTo(Integer value) {
            addCriterion("RThird <=", value, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdIn(List<Integer> values) {
            addCriterion("RThird in", values, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdNotIn(List<Integer> values) {
            addCriterion("RThird not in", values, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdBetween(Integer value1, Integer value2) {
            addCriterion("RThird between", value1, value2, "rthird");
            return (Criteria) this;
        }

        public Criteria andRthirdNotBetween(Integer value1, Integer value2) {
            addCriterion("RThird not between", value1, value2, "rthird");
            return (Criteria) this;
        }

        public Criteria andRelationIsNull() {
            addCriterion("Relation is null");
            return (Criteria) this;
        }

        public Criteria andRelationIsNotNull() {
            addCriterion("Relation is not null");
            return (Criteria) this;
        }

        public Criteria andRelationEqualTo(String value) {
            addCriterion("Relation =", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotEqualTo(String value) {
            addCriterion("Relation <>", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationGreaterThan(String value) {
            addCriterion("Relation >", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationGreaterThanOrEqualTo(String value) {
            addCriterion("Relation >=", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLessThan(String value) {
            addCriterion("Relation <", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLessThanOrEqualTo(String value) {
            addCriterion("Relation <=", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLike(String value) {
            addCriterion("Relation like", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotLike(String value) {
            addCriterion("Relation not like", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationIn(List<String> values) {
            addCriterion("Relation in", values, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotIn(List<String> values) {
            addCriterion("Relation not in", values, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationBetween(String value1, String value2) {
            addCriterion("Relation between", value1, value2, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotBetween(String value1, String value2) {
            addCriterion("Relation not between", value1, value2, "relation");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagIsNull() {
            addCriterion("InvoiceFlag is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagIsNotNull() {
            addCriterion("InvoiceFlag is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagEqualTo(Integer value) {
            addCriterion("InvoiceFlag =", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagNotEqualTo(Integer value) {
            addCriterion("InvoiceFlag <>", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagGreaterThan(Integer value) {
            addCriterion("InvoiceFlag >", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagGreaterThanOrEqualTo(Integer value) {
            addCriterion("InvoiceFlag >=", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagLessThan(Integer value) {
            addCriterion("InvoiceFlag <", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagLessThanOrEqualTo(Integer value) {
            addCriterion("InvoiceFlag <=", value, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagIn(List<Integer> values) {
            addCriterion("InvoiceFlag in", values, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagNotIn(List<Integer> values) {
            addCriterion("InvoiceFlag not in", values, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagBetween(Integer value1, Integer value2) {
            addCriterion("InvoiceFlag between", value1, value2, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvoiceflagNotBetween(Integer value1, Integer value2) {
            addCriterion("InvoiceFlag not between", value1, value2, "invoiceflag");
            return (Criteria) this;
        }

        public Criteria andInvtitleIsNull() {
            addCriterion("InvTitle is null");
            return (Criteria) this;
        }

        public Criteria andInvtitleIsNotNull() {
            addCriterion("InvTitle is not null");
            return (Criteria) this;
        }

        public Criteria andInvtitleEqualTo(String value) {
            addCriterion("InvTitle =", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleNotEqualTo(String value) {
            addCriterion("InvTitle <>", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleGreaterThan(String value) {
            addCriterion("InvTitle >", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleGreaterThanOrEqualTo(String value) {
            addCriterion("InvTitle >=", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleLessThan(String value) {
            addCriterion("InvTitle <", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleLessThanOrEqualTo(String value) {
            addCriterion("InvTitle <=", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleLike(String value) {
            addCriterion("InvTitle like", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleNotLike(String value) {
            addCriterion("InvTitle not like", value, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleIn(List<String> values) {
            addCriterion("InvTitle in", values, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleNotIn(List<String> values) {
            addCriterion("InvTitle not in", values, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleBetween(String value1, String value2) {
            addCriterion("InvTitle between", value1, value2, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvtitleNotBetween(String value1, String value2) {
            addCriterion("InvTitle not between", value1, value2, "invtitle");
            return (Criteria) this;
        }

        public Criteria andInvcontentIsNull() {
            addCriterion("Invcontent is null");
            return (Criteria) this;
        }

        public Criteria andInvcontentIsNotNull() {
            addCriterion("Invcontent is not null");
            return (Criteria) this;
        }

        public Criteria andInvcontentEqualTo(String value) {
            addCriterion("Invcontent =", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentNotEqualTo(String value) {
            addCriterion("Invcontent <>", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentGreaterThan(String value) {
            addCriterion("Invcontent >", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentGreaterThanOrEqualTo(String value) {
            addCriterion("Invcontent >=", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentLessThan(String value) {
            addCriterion("Invcontent <", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentLessThanOrEqualTo(String value) {
            addCriterion("Invcontent <=", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentLike(String value) {
            addCriterion("Invcontent like", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentNotLike(String value) {
            addCriterion("Invcontent not like", value, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentIn(List<String> values) {
            addCriterion("Invcontent in", values, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentNotIn(List<String> values) {
            addCriterion("Invcontent not in", values, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentBetween(String value1, String value2) {
            addCriterion("Invcontent between", value1, value2, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvcontentNotBetween(String value1, String value2) {
            addCriterion("Invcontent not between", value1, value2, "invcontent");
            return (Criteria) this;
        }

        public Criteria andInvdateIsNull() {
            addCriterion("InvDate is null");
            return (Criteria) this;
        }

        public Criteria andInvdateIsNotNull() {
            addCriterion("InvDate is not null");
            return (Criteria) this;
        }

        public Criteria andInvdateEqualTo(String value) {
            addCriterion("InvDate =", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateNotEqualTo(String value) {
            addCriterion("InvDate <>", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateGreaterThan(String value) {
            addCriterion("InvDate >", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateGreaterThanOrEqualTo(String value) {
            addCriterion("InvDate >=", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateLessThan(String value) {
            addCriterion("InvDate <", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateLessThanOrEqualTo(String value) {
            addCriterion("InvDate <=", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateLike(String value) {
            addCriterion("InvDate like", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateNotLike(String value) {
            addCriterion("InvDate not like", value, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateIn(List<String> values) {
            addCriterion("InvDate in", values, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateNotIn(List<String> values) {
            addCriterion("InvDate not in", values, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateBetween(String value1, String value2) {
            addCriterion("InvDate between", value1, value2, "invdate");
            return (Criteria) this;
        }

        public Criteria andInvdateNotBetween(String value1, String value2) {
            addCriterion("InvDate not between", value1, value2, "invdate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}